class CreateScores < ActiveRecord::Migration
  def change
    create_table :scores do |t|
      t.integer :user_id
      t.integer :department_id
      t.integer :master_id
      t.string :acct_name
      t.integer :id_type_id
      t.string :id_no
      t.string :phone
      t.integer :bus_type_id
      t.integer :acct_type_id
      t.string :acct_no
      t.date :create_date
      t.decimal :amount, precision: 16, scale: 4
      t.integer :term_type_id
      t.integer :day_num
      t.integer :score
      t.integer :stan
      t.date :freeze_date
      t.string :oprm
      t.text :desc

      t.timestamps null: false
    end
  end
end
